Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | Supplier(PA_SPR) |
DealCode (PK) | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. | LU_DL | Code6 | char(6) | |
Name | The business name for the deal. | NM_DL | Name | varchar(40) | |
Description | A brief text description of the DEAL. | DE_DL | DescriptionShort | varchar(255) | |
EffectiveDate | The start date upon which an ITEM can be ordered under the terms of a given deal. | DC_DL_EF | EffectiveDate | date | |
ExpirationDate | The end date upon which an ITEM can be ordered under the terms of a given deal. | DC_DL_EL | ExpirationDate | date | |